Views [dbo].[vSoaGroupSummaryMeeting]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Schema BoundYes
Created9:36:22 PM Wednesday, August 24, 2011
Last Modified9:36:22 PM Wednesday, August 24, 2011
Columns
Name
Cluster Key PK_vSoaGroupSummaryMeeting: GroupIdGroupId
ParentEntityTypeName
ParentEntityId
GroupClassId
Name
Indexes Indexes
NameColumnsUnique
Cluster Key PK_vSoaGroupSummaryMeeting: GroupIdPK_vSoaGroupSummaryMeetingGroupId
Yes
SQL Script

CREATE VIEW [dbo].[vSoaGroupSummaryMeeting]
WITH SCHEMABINDING
AS
    SELECT  'EVENT-' + [Meet_Master].[MEETING] AS [GroupId],
            'Public' AS [ParentEntityTypeName],
            'Public Groups' AS [ParentEntityId],
            'EVENT' AS [GroupClassId],
            [Meet_Master].[TITLE] AS [Name]
      FROM  [dbo].[Meet_Master]


GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupSummaryMeeting] ON [dbo].[vSoaGroupSummaryMeeting] ([GroupId]) ON [PRIMARY]
GO
Uses
Used By